Statistics for Maintenance Modelling: Continuous Lifetime Distributions 2

# Calculating the Normal Distribution Using Excel¤

The Excel function:

NORMDIST(x, mean, standard_dev, cumulative)

calculates the normal probabilities. The parameters of this Excel function are:

- x corresponds to t in our notation
- mean corresponds to in our notation
- standard_dev corresponds to in our notation
- cumulative is false if it's the normal probability density function that you require and true if it's the normal cumulative distribution function that you want instead.

The inverse of the cumulative distribution function is given by the Excel function:

NORMINV(probability, mean, standard_dev)

Excel also contains NORMSDIST() and NORMSINV() for the standard normal distribution - these are just the more general normal distributions with = 0 and = 1.

Close